Omit parameter property always resets to "false"
Dear professionals,
I would like to implement a conditional drillthrough from one report to other reports by jumping to them. For that I need to omit parameters which are not implemented in the other target report.
The omit property of the parameters accept my expression (let's say "true" instead of the default "false") when returning to the action pane. However, when clicking "ok", returning to the report and afterwards opening the omit property expression again,
the expression is the default "false" again. Therefore, I cannot set the omit property and use this feature.
I tried it with several expressions in RS 2008 and RS 2008 R2.
Does anybody have a hint on this issue? I would appreciate it.
Thanks in advance!
April 8th, 2011 7:58am
Hi Tilo,
Thanks for your question, I test your scenario in local environment, it works fine. To this abnormal behavior, I would recommend restart your computer, and then open the project again. If the issue still exist, you could open the report's XMl file then paste
below XML manually to make sure OMIT property is set:
<ActionInfo> <Actions> <Action> <Drillthrough> <ReportName>Subreport</ReportName> <Parameters> <Parameter Name="Category"> <Value>=Fields!Category.Value</Value> </Parameter> <Parameter Name="ReportParameter1"> <Value>True</Value> <Omit>true</Omit> </Parameter> </Parameters> </Drillthrough> </Action> </Actions> </ActionInfo>
Replace the relevant node with your subreport's information.
Thanks,
Challen Fu
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 10th, 2011 11:17pm
Hi Challen Fu,
thanks for your reply!
First I thought, a restart just made the issue solved. Now, I found the combination where it doesnt seem to work via the UI:
1. create a drillthrough action to a report, add a parameter. Change the omit-Value. This works.
2. create an Expression for the target report (targeting 2 reports depending on a condition). Save. Change the omit-value of the parameter somehow. click ok, save, return to the omit-expression. The value is reset to the former expression.
This leads to a workaround: Define the omit values while one target report is selected from the dropdown-list. Change the target report expression afterwards.
Is it possible for you to confirm this behaviour? :)
Many thanks!
April 11th, 2011 4:59am
i had the same problem, tried your tip and worked partially,
in my case i have to change to diferent report from the list to save or update my "omit" expresions,
at the end i set the expression for the selected report again.
tanks Tilo, i hope they release some fix soon.me.
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2011 7:29pm
I observed, that the issue only applies to charts and it's actions. Tables work fine.
April 27th, 2011 8:31am
Same with Bing Maps control here (2008 R2). Editing XML source worked - thanks for sharing.
Regards
Marc
Free Windows Admin Tool Kit Click here and download it now
August 8th, 2012 5:23am